Vlookup with isnumber formula

hA! Sweet - had to make a minor correction

=IFERROR(VLOOKUP($A8,IF(ISNUMBER('Availability '!$B$3:$AH$4500),'Availability '!$B$3:$AH$4500,'Availability '!$B$3:$AH$4500*1),10,FALSE)*1,"") <-- FROM

=IFERROR(VLOOKUP($A8,IF(ISNUMBER('Availability '!$B$3:$AH$4500*1),'Availability '!$B$3:$AH$4500,'Availability '!$B$3:$AH$4500*1),10,FALSE),"") <-- TO

You did, thank you, I apprecaite it!

Good day, I'd like to add a question about the same scenario except...

I want to lookup a part number in a list, but use ISNUMBER(SEARCH("4-*",'Column'!$A2)) to pull specific data from the data column which contains various values. If the value starts with 4 in the data column it would pull that value and nothing else. I guess similar to match.

THanks.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Also, on an unrelated note, showing your location helps us tailor solutions to work with your specific regional settings. Your country would be sufficient without compromising your privacy.

My apologies...

I solved it - =IF(ISNUMBER(SEARCH("3-*",'[Book6]3'!$E:$E,1)),VLOOKUP($B3,'[Book6]3'!$A:$E,5,0),"")