Forum Discussion

Copper Contributor

Apr 16, 2020

VLOOKUP usage to find a match and autofill in Database

Hello, Recently while i'm working on creating a database and tried to use Vlookup function which I used till yesterday to be working as required. But now using the VLOOKUP for similar purpose to find...

excel

SergeiBaklan

Diamond Contributor

Apr 16, 2020

Ravi_Shankar

First to check if cells are really match - in any empty cell type something like =A1=H23 if VLOOKUP returns an error for this pair. If result is TRUE when something is wrong with formula, if FALSE - with data.

Better to have sample to be more concrete.

Ravi_Shankar
Copper Contributor
Apr 16, 2020
SergeiBaklanThank you Mr.Sergei Baklan. I tried to input some another value as suggested by you, with an alphabet and numeric in a cell and the same in the array table (for example: replaced 5861 with A1) and then able to find the result, and it worked. Now not sure what to do next in this case and what's wrong before only with the number? Any suggestions?
- SergeiBaklan
  Diamond Contributor
  Apr 16, 2020
  Ravi_Shankar
  
  Most probably lookup value and array have different data types - number and text, e.g. 1234 and "1234".
  
  If lookup value is text you may lookup it as VALUE(A1). If values in the range better to transform the to numbers. Only changing of data type is not enough, values shall be re-entered. Manually, or by Text to Columns, or by Paste Special -> Add, whatever.