| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup two different columns
You're welcome! Glad you got it working.
-- Kevin Vaughn "Sunryzz" wrote: You are very correct. I found out the reason for my N/A's this time was a leading space in one of the columns. Thanks again for all your help!! "Kevin Vaughn" wrote: Text should work (just look out for trailing spaces etc.) -- Kevin Vaughn "Sunryzz" wrote: OK, one more question (I hope). If the items in my columns are text instead of numbers, does that make a difference? So, my Line column is Air Piping, Frame, Main, etc? It was working, but now I'm trying to use it for a text version of the same thing and it is coming back with N/A again. GRRRRR! "Kevin Vaughn" wrote: Sunryzz Wrote: I keep getting N/A for the answer, but I can't figure out why. Here is my formula. =INDEX(Sheet2!C1:C10,MATCH(1,(Sheet2!A1:A10=Sheet1 !A2)*(Sheet2!B1:B10=Sheet1!B2),0)) Try some formulas to see which part is failing. It appears that you expect that somewhere on rows 1 through 10 fo sheet 2, both a cell in A is going to match what is in A2 of sheet 1 and a cell in B (of the same row) is going to match what is in B2 of sheet 1. So try 2 different formulas. Let's say that the row that you think should match both A and B is row 2. Try a formula that tests this. Like a formula in sheet1: =A2=Sheet2!A2 If this does not return true, there is your problem. Check for things like trailing spaces. and =B2=Sheet2!B2 should also return true. Also, as I'm sure was mentioned in the original post as this is an array formula it MUST be entered using Ctrl-Shift-Enter, not just Enter. -- Kevin Vaughn ------------------------------------------------------------------------ Kevin Vaughn's Profile: http://www.excelforum.com/member.php...o&userid=34857 View this thread: http://www.excelforum.com/showthread...hreadid=546044 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL should let me establish unlimited numbers of columns. | Excel Discussion (Misc queries) | |||
| Lookup Two Columns - Again | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| Lookup function skipping columns | Excel Worksheet Functions | |||
Threaded Mode
