Forum Discussion
Auto filling fields and calculations
- Hello Mark,
Assuming your Table Labels are in A1:E1, your formulas you need are:
A2=IF(C1="Card",A1,"")
B2=IF(C1="Card","Card Fees","")
C2=IF(C1="Card","Electronic","")
D2=IF(C1="Card",E1*0.0175,"")
Hi Emo66!
I presume, you copied & pasted your excel table from your MAC into your post? Unfortunetaly I made the same as I tried to figure out a solution for you. My Excel broke because of the mac (taiwanese) formattings in there... But i finally have a solution for you. see my screenshot.
Formula name in german:
SVerweis(the cell you are searching within a matrix, then the matrix, then the number of columns in the matrix, then a zero for find the exact first number in your matrix)
NOTE: In german formulas we have the ";", you have to write it with a comma!
The formula name is in english: VLOOKUP and you need a second list (matrix is a table without the headers!) in the right side next to your calculating list column.
Additionally i converted the first list as a table object. It behaves like a common database and is perfect for doing things automatically in the next lines.
I wish you a nice weekend. Greets, Eva.
Hi Eva, Thank you for taking the time to look at this problem.
I'm not sure why Taiwanese formatting is there as I have never used this language. Also, I did not copy and paste the table, I manually typed it into the message screen to look similar to my Excel page.
It's been a long time since I have had to use VLookup but I think I understand what you are saying.
Thank you again for your advice.
Regards,
Mark.
Hi Mark,
sorry. There was an issue on my own excel app to cause that cell formatting trouble within my sheets..., was my fault. Say, if it works so far with the vlookup. It could be easier to remind some good tricks like the tutorials about it on youtubes channel called "ExcelIsFun", check this out!
Greets, Eva.