I need some help with formulas and referencing cells in Excel. I've used Excel before for simple tasks like
finding the sum of number etc. but I've never used it for anything more complicated than that.
I've attached the
file I'm working on.
In there, is a worksheet called "Clients", and a worksheet called "Form".
(I'll format the form later Sheet "Clients" contains all the data, and sheet "Form" is where all the
I've created a dropdown list in sheet "Form", that takes its data from sheet
"Clients". When i select "Business A" in sheet "Form", all data related to "Business A'
which is stored in a row in sheet "Clients", needs to appear in sheet "Form".
My problem is,
I've managed to do it for "Business A", but when I choose "Business B" how do I tell Excel to look for
data in cells B3 C3 D3 and not B2 C2 D2. Its hard to explain here.
I'm sure you'll understand what i'm trying to
do if you looked at the Excel file and selected Business B and Business C from the dropdown list. There might be some method
like using * (wild cards) to reference cell numbers.
I did a formula =IF(B1="Business
A",Clients!C2,"Error") with a lot of difficulty.
Also, is it possible to use an easier reference
instead of "Business A" "Business B" in the formula. (Only in the formula and not in the drop down