Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return one nu
Looked at some of you responses regarding excel and you seem very
knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Cant figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return one nu
If you don't mind a suggestion from someone else - assuming check numbers are
in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Cant figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return one nu
=MIN(IF(B1:C3=A10,A1:A3,""))
The "" are superfluous. Biff "JMB" wrote in message ... If you don't mind a suggestion from someone else - assuming check numbers are in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Can't figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return on
jb...Does it works ? I have the same problems. I cant do it with my invoice
list, my invoice numbers are scattered around, only the check numbers are in sequence ? Still a mystery... "Biff" wrote: =MIN(IF(B1:C3=A10,A1:A3,"")) The "" are superfluous. Biff "JMB" wrote in message ... If you don't mind a suggestion from someone else - assuming check numbers are in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Can't figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return on
I realized that after I'd already posted. I hoped nobody would notice.
Hope you are not offended I posted since the OP requested your help. I wasn't going to, but then I figured it was not certain you would see the post. "Biff" wrote: =MIN(IF(B1:C3=A10,A1:A3,"")) The "" are superfluous. Biff "JMB" wrote in message ... If you don't mind a suggestion from someone else - assuming check numbers are in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Can't figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return on
Hope you are not offended I posted since the OP requested your help.
Absolutely not. I've done the same thing. Biff "JMB" wrote in message ... I realized that after I'd already posted. I hoped nobody would notice. Hope you are not offended I posted since the OP requested your help. I wasn't going to, but then I figured it was not certain you would see the post. "Biff" wrote: =MIN(IF(B1:C3=A10,A1:A3,"")) The "" are superfluous. Biff "JMB" wrote in message ... If you don't mind a suggestion from someone else - assuming check numbers are in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Can't figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIFF - Help!! lookup numbers in multiple columns and return on
excuse me Biff and Jmb....Hi jb...pls reply so we learn for the correct
formula on a logical function...since no one had replied for a lookup/reference formulation....it seems "IF's" is more helpful in this case - money matters....waiting for your reply... "Biff" wrote: Hope you are not offended I posted since the OP requested your help. Absolutely not. I've done the same thing. Biff "JMB" wrote in message ... I realized that after I'd already posted. I hoped nobody would notice. Hope you are not offended I posted since the OP requested your help. I wasn't going to, but then I figured it was not certain you would see the post. "Biff" wrote: =MIN(IF(B1:C3=A10,A1:A3,"")) The "" are superfluous. Biff "JMB" wrote in message ... If you don't mind a suggestion from someone else - assuming check numbers are in A1:A3, invoice numbers are in B1:C3, the invoice number you're looking for is in A10 (change cell references as needed), you could try =MIN(IF(B1:C3=A10,A1:A3,"")) array entered with Cntrl+Shift+Enter (or you'll get #VALUE!). Also, assumes the invoice was paid w/only one check. "jb" wrote: Looked at some of you responses regarding excel and you seem very knowledgeable. Have a question involving a lookup. Scenario Two Sheets Sheet one Has an invoice number on it. Sheet two Has a check number that may or may not have paid multiple invoices. It is listed this way. Column 1 column 2 column 3 et all Check number invoice number invoice number What I would like to do is use a lookup on sheet one that checks sheet two for the invoice number (separate invoice numbers are located in columns B through whatever) and returns what check it was paid on (checks located in the left most column). Can't figure out an easy way to do it and was wondering if you had any ideas. Regards, jb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
lookup across multiple columns | Excel Worksheet Functions | |||
Can I return multiple columns from a vlookup? | Excel Worksheet Functions | |||
Lookup with multiple value return | Excel Worksheet Functions |