Hi,
I need to combine IF and Vlookup.
I need a formula that find if a cell (C4) contains the word 'Exclusive'.
If it does I want it to do a vlookup on the value in C5.
Can anyone help?
Regards
Ben
Hi,
I need to combine IF and Vlookup.
I need a formula that find if a cell (C4) contains the word 'Exclusive'.
If it does I want it to do a vlookup on the value in C5.
Can anyone help?
Regards
Ben
hi Ben. maybe something like:
=IF(C4="Exclusive",VLOOKUP(C5,table_array,col_index_num,[range_lookup]),"")
input your VLOOKUP formula in the red portion.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you so much. This works a treat, but just realised that if it's another value then it affects my formula returns a horrible. Are you able to change the formula so that if there is the word Exclusive it returns the value 100%? I only have the two options.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks