The theory for vlookups is as follows:
=VLOOKUP(cell reference, corresponding range of cells to link to, column number to output, false)
An example is as follows:
=VLOOKUP(A2,$C$2:$D$30,2,FALSE)
The formula above will link cell A2 to cells C2 to C30. Note the values in cells C2 to C30 must be the same type as the values in column A where cell A2 exists. The number 2 means that the data returnerd from the vlookup formula would be from the 2nd column to column C, which would be Column D. The most appropriate data to use as the link reference or lookup cell reference would be unique identifiers. So column A and cells C2 to C30 would work perfectly with them both being customer id columns or employee id columns. That would be the most appropriate way to match any data. The word: "False" means: Find an exact match.
=VLOOKUP(cell reference, corresponding range of cells to link to, column number to output, false)
An example is as follows:
=VLOOKUP(A2,$C$2:$D$30,2,FALSE)
The formula above will link cell A2 to cells C2 to C30. Note the values in cells C2 to C30 must be the same type as the values in column A where cell A2 exists. The number 2 means that the data returnerd from the vlookup formula would be from the 2nd column to column C, which would be Column D. The most appropriate data to use as the link reference or lookup cell reference would be unique identifiers. So column A and cells C2 to C30 would work perfectly with them both being customer id columns or employee id columns. That would be the most appropriate way to match any data. The word: "False" means: Find an exact match.
0 comments:
Post a Comment