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
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
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.
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.
ASKER
Hello,
the formula is not bringing the proper values.
I attached another test file
the formula is not bringing the proper values.
I attached another test file
Please attach the file.
I will edit as per your requirement.
I will edit as per your requirement.
ASKER
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).
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
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very Much.
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