LinkBack URL
About LinkBacks
Thank you guys! Sorry for my struggle articulating my questions.
Awesome, TMS--how do I format the Index value within the vlookup formula to accomplish that?
Thank you guys! Sorry for my struggle articulating my questions.
Awesome, TMS--how do I format the Index value within the vlookup formula to accomplish that?
Without using X1:Formula:
=VLOOKUP(10251, A1:L1000, IF(AND(A1="true", B1="false", C1="4x6"), D1*E1, F1*G1), FALSE)
Which makes interesting reading as you are looking for a numeric value in column A but then A1 is shown as potentially = "true".
Getting confused now ...
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks