Vlookup question
i tried to apply the below, but no luck. what i dont understand is that out
of say a 100 lines, 4-5 will do work and it does bring up the relevant field
from worksheet B, but i get N/A for the rest.
"venumadhav g" wrote:
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?
|