Link to home
Start Free TrialLog in
Avatar of W.E.B
W.E.B

asked on

Multi vLookup (Excel vba)

Hello,
Can you please help me with a Sub.,
I have about 3000 Rows.
I'm trying to Lookup the weight, Zone , and get the price back (from 3 sheets).
and Highlight the lowest value.
Please see attached sample.

After I review the results,
I need to only keep the Lowest highlighted values.

Your help is appreciated.
thanks
TEST.xls
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi,

Please find attached as per your attached sheet. Just simple formula and conditional formatting.

If you want in VBA, I can do that too.

Please advice.
TEST.xls
Avatar of W.E.B
W.E.B

ASKER

Hi Shums.
Thank you for your help,
a VBA would work better, I need to include this with another vba.

Also,
I need to please highlight the lowest of the 3 prices (each Row).

thanks again.
Avatar of W.E.B

ASKER

Hello,
the formula is not bringing the proper values.
I attached another test file
Please attach the file.

I will edit as per your requirement.
Hi Wass,


Please find attached...still its formula based sheet.

Do you still need VBA?
TEST_2.xlsx
Avatar of W.E.B

ASKER

Hi Shums,
I'll work with the formula, thanks,
I'm testing it now,
Question,
Row 20,    it has Weight 56,  it should have returned N/A, OR no value.

how can I highlight the lowest of 3 prices (for each row).
Hi Wass,

Please find attached, corrected the error which will result in blank cell and highlighted the lowest of 3 prices of each zone.
TEST_2.xlsx
Avatar of W.E.B

ASKER

Appreciate all your help Shums,
still not highlighting
It's only highlighting cells Rows (7,13,18)

it should highlight one cell per row (Comparing price in Column D,F,H).
Examples
Example Row 2:           D2 should be highlighted (lowest Price 1.53)
Example Row 3:           D3 should be highlighted (Lowest Price 1.16)
Example Row 7:           D7 should be highlighted (Lowest Price 0.71)
and so on.

I wouldn't mind a vba to highlight the lowest instead of conditional formatting.

thanks again
Hi Wass,

Please find attached...Zone_1 has smaller value compared to other Zone.
TEST_2.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of W.E.B

ASKER

Thank you very Much.