Formula Help

[4wwest]

I am needing assistance on a formula.

I will input data in Type Column, I want the forumla to look at the Type Choice Column and bring back the Class Result to the Class Field. Having some trouble making it work.

Capture.JPG


Many Thanks
Todd

[mcmahobt]

Assuming your data starts in cell A1, which contains "Type", in cell B3 enter:

Please Login or Register  to view this content.

And drag down. This returns a result as long as there is a corresponding match in the abreast cell within column A.

Hope this helps!

[AlKey]

Try this in B2

=IFERROR(VLOOKUP(A2,C:D,2,0),"Not Found")

Row\Col	A	B	C	D
1	TYPE	CLASS	TYPE CHOICE	CLASS RESULT
2	2 B	7945	2 B	7945
3			6 B	7965
4			Exp	7916
5			Wall	6921

[FDibbins]

4wwest, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[4wwest]

Thank you for your feedback. I will try to make my description more explanatory in the future.

[4wwest]

Thank you. That worked very nicely.

[AlKey]

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).