Managing Data on excel

Originally Posted by AlKey

Please see attached file with two sheets: AccountView and Data. On AccountView sheet you can enter account number and data will populate in the cells below.

The OP wants to do the VLOOKUP based on the customer name, so to use VLOOKUP, the customer name and account number columns need to be reversed in the data table so theat the lookup column (customer) is leftmost. The AccountView tab could be enhanced with a drop-down box for the customer name using a data validation list that refers to the customer column on the Data tab.

For the OP's benefit:

What a VLOOKUP query does is match the lookup value in the leftmost column of the array given in the formula, then looks across to the column stated and returns that result.

=VLOOKUP(lookup_value, lookup_array, column_number_in_array, true/false) where false returns an exact match and true returns an approximate match.

Originally Posted by AliGW

to use VLOOKUP, the customer name and account number columns need to be reversed in the data table so that the lookup column (customer) is leftmost

Not necessarily... look at the examples in the link I provided the OP.

Originally Posted by abousetta

Not necessarily... look at the examples in the link I provided the OP.

I missed that! Very interesting ... :-)

Originally Posted by blueblink01

Dear all,

Another way is to use Index Function. This function is better than vlookup

Thanks

Define "better".