Vlookup question
Hi Daniel,
Please try the below lookup
=VLOOKUP(B1,Sheet1!$A$1:$B$23,2,FALSE)
in sheet b or sheet 2 in column c1
"Daniel" wrote:
Hi. i have a workbook with multiple worksheets and some of them contain
matching data. say, i have worksheet A where i have numbers in column 1, and
i have worksheet B where i have numbers in column 1 (some of them matching
the ones in worksheet A), and have Comments in column 2. i want to pull up
the comments in worksheet A where column 1 has matching data to worksheet B
column 1. i tried a simple Vlookup but i always get N/A. hope this makes
sense. any suggestions?
|