Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup OR If Function?
Hi,
hope I can explain what I'm trying to do. Let say, in one sheet column a I have Part 10-154 Then in another sheet column A I have part 10-154PBF. I know when I do a Vlookup it doesn't find it because they don't match. So is there a way to bring it basically if part is almost same the difference is the last 3 digits. So what I'm thinking is it would look like Column A Column B 10-154 10-154PBF Or maybe there is a if function i can use? Would appreciate any help Thanks, JH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine Combo Box function with Vlookup function | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |