ExcelBanter - If return

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If return (https://www.excelbanter.com/excel-discussion-misc-queries/166689-if-return.html)

Nicole

If return

I need some help please...
If C2 = A:A than I want it to return the number that is in B:B next to the
match of C2

Quick report Number of Line Items Entry Number
3696821-7 1 7076693-1
3696901-7 1 9058675-6
7076693-1 68 8700137-1
8700008-4 2 8700136-3
8700009-2 1 8700135-5

So if 7076693-1 is found in quick report give me 68

Bernard Liengme

If return

=vlookup(C2,A2:B100,2,false)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"nicole" wrote in message
...
I need some help please...
If C2 = A:A than I want it to return the number that is in B:B next to the
match of C2

Quick report Number of Line Items Entry Number
3696821-7 1
7076693-1
3696901-7 1
9058675-6
7076693-1 68
8700137-1
8700008-4 2
8700136-3
8700009-2 1
8700135-5

So if 7076693-1 is found in quick report give me 68

All times are GMT +1. The time now is 01:58 AM.