Please help me , in a spreadsheet working

Dear it is not possible to explain the formula without any data rather it wud be difficult for you to understnand the command properly.

If possible, u can fwd ur sheet on my personal ID---- garganujgarg @ yahoo.co.in

i will explain you everything, if i can

TYPE AS BELOW:

=VLOOKUP(A, Z:ZZ, 4, FALSE)

WHERE: A  = YOUR COMMON DATA IN SECOND SHEET WHICH YOU WANT TO SEARCH IN FIRST SHEET

Z:ZZ = THE RANGE OF DATABASE IN FIRST SHEET STARTING FROM THE COMMON DATA COLUMN AND ENDING WITH THE DATA YOU WANT TO CALL IN SECOND SHEET FROM THE FIRST SHEET.

4 = THE COLUMN NO. IN YOUR RANGE (Z:ZZ) SELECTION (e.g if your range is B1:F50, and your common data is in 'B' column, desired respective data is in 'F' column then you should write 5 instead of 4)

FALSE: THIS MEANS YOU WANT TO MATCH EXACTLY...

Easiest way to understand VLOOKUP and HLOOKUP, none other than a video. Just click on the below link:

https://www.brainstorminc.com/cbt/microsoft/help.php?file=excel3

Good information.

Thanks, dashrath,

I got it man. but still i am not fully getting the information when the range is Z:ZZ , and the common field has multiple numbers like say bill no 01/123 is repeating in three rows, then the search is breaking and the value is showing as #NA. Can you please tell the way out.

Just download this file and follow the procedure, it has a new GKPlookup tool which will solve your problem...

**DM

The range moves down cell by cell as and when the formula is copied in the column. put a dollar sign before the cell numbers so that the selection range is frozen.

eg $A$1:$E$50