Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup for multiple columns
Hello excel wizards!
I have a dilemna that I hope you can help with. I want to use the vlookup function (or something like it) to say if (cellx in Sheet1 column A is equal to = Sheet2A1) AND (cellx in Sheet1 column B is equal to = cellx in Sheet2B1) then input the value from cellx in Sheet column C into Sheet2C1. I can do this using the IF function, but it only works if the cells being compared on the two separate sheets are in the same row. Is there a way to do it where the cells being compared aren't in the same row (this is why I think I need to use vlookup)? Thanks for your time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
Is there a way to do a vlookup to look up two columns versus one? | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Moving columns with VLOOKUP formulas | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |