Forum Discussion

Copper Contributor

Apr 09, 2019

Solved

HELP WITH FORMULAS TO AUTO-POPULATE A TABLE

I am looking for help with the attached sheet, where I have student names in one column and would like to extract their marks in English scored in H1 and H2. In the current sheet I have entered the ...

Excel Help.xlsx11 KB

excel

Formulas and Functions

SergeiBaklan
Apr 10, 2019
shyam_amara , you are welcome. Another useful function is IFERROR() to wrap any error, not only #N/A

shyam_amara

Copper Contributor

Apr 09, 2019

Thanks Sergei. I must say the IFNA is a real saver for me. Did not know that such a function exists! I use lot of Vlookup and was always pestered by the #N/A. Now I know how to deal with it. Thanks much.

SergeiBaklan

Diamond Contributor

Apr 10, 2019

shyam_amara , you are welcome. Another useful function is IFERROR() to wrap any error, not only #N/A

shyam_amara
Copper Contributor
Apr 11, 2019
SergeiBaklan thanks for your help. I have another problem that needs to be solved. I have mentioned the problem in the link below. Could you please help?

https://techcommunity.microsoft.com/t5/Excel/Lookup-Pattern-Cascading/m-p/440291
- SergeiBaklan
  Diamond Contributor
  Apr 12, 2019
  shyam_amara , is says the post was deleted