Hi there,
I want to seek out the result of Cell Y10 (it contains a formula, but l want to look at the result)
I want to seek it out in the range C10:C254
I want to cross reference that entry in C10:C254 with the entry for Column K on the same row.
I cannot think what the formula would be - any ideas? I have Googled but as ever, l find anything but the simple thing l'm asking for :D
May be:
=LOOKUP(2,1/($C$10:$C$254=$Y10),$K$10:$K$254)
Quang PT
Hi there thank you for your help. Please may l have clarification of the formula because the one you submitted gives a div/0 error
Sorry, never mind, l have made an error anyway
Is it a partial match? i.e, "Trump" in range of "Donald Trump", "Barrack Obama"...
Try:
=LOOKUP(2,1/ISNUMBER(SEARCH($Y10,$C$10:$C$254)),$K$10:$K$254)
If it does not work, try to upload a sample worksheet.
Hi there, when you include the "/" sign, my spreadsheet takes that as a division by zero.
If there was no Y10 value found in C10:C254, it return blank:
=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH($Y10,$C$10:$C$254)),$K$10:$K$254),"")
Thank you i think that works better but l realised l made a mistake anyway, the value in Y10 was too big, l only wanted a small part of the string, not the whole string, so l was really asking the wrong question anyway
Thanks though!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks